/**
 * BladeX Commercial License Agreement
 * Copyright (c) 2018-2099, https://bladex.cn. All rights reserved.
 * <p>
 * Use of this software is governed by the Commercial License Agreement
 * obtained after purchasing a license from BladeX.
 * <p>
 * 1. This software is for development use only under a valid license
 * from BladeX.
 * <p>
 * 2. Redistribution of this software's source code to any third party
 * without a commercial license is strictly prohibited.
 * <p>
 * 3. Licensees may copyright their own code but cannot use segments
 * from this software for such purposes. Copyright of this software
 * remains with BladeX.
 * <p>
 * Using this software signifies agreement to this License, and the software
 * must not be used for illegal purposes.
 * <p>
 * THIS SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY. The author is
 * not liable for any claims arising from secondary or illegal development.
 * <p>
 * Author: Chill Zhuang (bladejava@qq.com)
 */
package org.springblade.modules.students.controller;

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;
import io.swagger.v3.oas.annotations.tags.Tag;
import io.swagger.v3.oas.annotations.Operation;
import io.swagger.v3.oas.annotations.Parameter;
import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
import lombok.AllArgsConstructor;
import jakarta.validation.Valid;

import org.springblade.common.constant.CommonConstant;
import org.springblade.core.secure.BladeUser;
import org.springblade.core.secure.annotation.PreAuth;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
import org.springblade.core.secure.utils.AuthUtil;
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.utils.DigestUtil;
import org.springblade.core.tool.utils.Func;
import org.springblade.modules.signup.pojo.entity.QyCardTypesEntity;
import org.springblade.modules.signup.pojo.entity.QyStudentsOrderEntity;
import org.springblade.modules.system.pojo.entity.User;
import org.springblade.modules.system.service.IUserService;
import org.springframework.web.bind.annotation.*;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.springblade.modules.students.pojo.entity.QyStudentsEntity;
import org.springblade.modules.students.pojo.vo.QyStudentsVO;
import org.springblade.modules.students.excel.QyStudentsExcel;
import org.springblade.modules.students.wrapper.QyStudentsWrapper;
import org.springblade.modules.students.service.IQyStudentsService;
import org.springblade.core.boot.ctrl.BladeController;
import org.springblade.core.tool.utils.DateUtil;
import org.springblade.core.excel.util.ExcelUtil;
import org.springblade.core.tool.constant.BladeConstant;
import org.springblade.core.tool.constant.RoleConstant;

import java.io.IOException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

import jakarta.servlet.http.HttpServletResponse;
import org.springframework.web.multipart.MultipartFile;

import static org.springblade.common.utils.CommonUtil.calculateAge;

/**
 * 学员管理 控制器
 *
 * @author BladeX
 * @since 2024-06-15
 */
@RestController
@AllArgsConstructor
@RequestMapping("blade-qyClasses/qyStudents")
@Tag(name = "学员管理", description = "学员管理接口")
public class QyStudentsController extends BladeController {

	private final IQyStudentsService qyStudentsService;
	private final IUserService userService;

	/**
	 * 从User表更新
	 */
	@GetMapping("/refleshfromUser")
	@ApiOperationSupport(order = 1)
	@Operation(summary = "详情", description  = "传入qyStudents")
	public R refleshfromUser( ) {

		return R.data("");
	}


	/**
	 * 学员管理 详情
	 */
	@GetMapping("/detail")
	@ApiOperationSupport(order = 1)
	@Operation(summary = "详情", description  = "传入qyStudents")
	public R<QyStudentsVO> detail(QyStudentsEntity qyStudents) {
		QyStudentsEntity detail = qyStudentsService.getOne(Condition.getQueryWrapper(qyStudents));
		return R.data(QyStudentsWrapper.build().entityVO(detail));
	}

	public static String maskPhoneNumber(String phoneNumber) {
		if (phoneNumber == null || phoneNumber.isEmpty()) {
			return phoneNumber;
		}

		String pattern = "(\\d{3})\\d{4}(\\d{4})";
		String replacement = "$1****$2";

		Pattern p = Pattern.compile(pattern);
		Matcher m = p.matcher(phoneNumber);

		return m.replaceAll(replacement);
	}


	/**
	 * 学员管理 分页
	 */
	@GetMapping("/list")
	@ApiOperationSupport(order = 2)
	@Operation(summary = "分页", description  = "传入qyStudents")
	public R<IPage<QyStudentsVO>> list(@Parameter(hidden = true) @RequestParam Map<String, Object> qyStudents, Query query) {
		IPage<QyStudentsEntity> pages = qyStudentsService.page(Condition.getPage(query), Condition.getQueryWrapper(qyStudents, QyStudentsEntity.class));
		pages.getRecords().forEach(item->{
			item.setPhone(maskPhoneNumber(item.getPhone()));
			if(item.getBirthday() != null){
				item.setAge( calculateAge(item.getBirthday(),new Date()));
			} else{
				item.setAge(0);
			}

		});
		return R.data(QyStudentsWrapper.build().pageVO(pages));
	}

	/**
	 * 学员管理 自定义分页
	 */
	@GetMapping("/page")
	@ApiOperationSupport(order = 3)
	@Operation(summary = "分页", description  = "传入qyStudents")
	public R<IPage<QyStudentsVO>> page(QyStudentsVO qyStudents, Query query) {
		IPage<QyStudentsVO> pages = qyStudentsService.selectQyStudentsPage(Condition.getPage(query), qyStudents);
		return R.data(pages);
	}

	/**
	 * 学员管理 新增
	 */
	@PostMapping("/save")
	@ApiOperationSupport(order = 4)
	@Operation(summary = "新增", description  = "传入qyStudents")
	public R save(@Valid @RequestBody QyStudentsEntity qyStudents) {
		return R.status(qyStudentsService.save(qyStudents));
	}

	/**
	 * 学员管理 修改
	 */
	@PostMapping("/update")
	@ApiOperationSupport(order = 5)
	@Operation(summary = "修改", description  = "传入qyStudents")
	public R update(@Valid @RequestBody QyStudentsEntity qyStudents) {
		return R.status(qyStudentsService.updateById(qyStudents));
	}

	/**
	 * 学员管理 新增或修改
	 */
	@PostMapping("/submit")
	@ApiOperationSupport(order = 6)
	@Operation(summary = "新增或修改", description  = "传入qyStudents")
	public R submit(@Valid @RequestBody QyStudentsEntity qyStudents) {
		return R.status(qyStudentsService.saveOrUpdate(qyStudents));
	}

	/**
	 * 学员管理 删除
	 */
	@PostMapping("/remove")
	@ApiOperationSupport(order = 7)
	@Operation(summary = "逻辑删除", description  = "传入ids")
	public R remove(@Parameter(name = "主键集合", required = true) @RequestParam String ids) {
		return R.status(qyStudentsService.deleteLogic(Func.toLongList(ids)));
	}


	/**
	 * 导出数据
	 */
	@PreAuth(RoleConstant.HAS_ROLE_ADMIN)
	@GetMapping("/export-qyStudents")
	@ApiOperationSupport(order = 9)
	@Operation(summary = "导出数据", description  = "传入qyStudents")
	public void exportQyStudents(@Parameter(hidden = true) @RequestParam Map<String, Object> qyStudents, BladeUser bladeUser, HttpServletResponse response) {
		QueryWrapper<QyStudentsEntity> queryWrapper = Condition.getQueryWrapper(qyStudents, QyStudentsEntity.class);
		//if (!AuthUtil.isAdministrator()) {
		//	queryWrapper.lambda().eq(QyStudents::getTenantId, bladeUser.getTenantId());
		//}
		queryWrapper.lambda().eq(QyStudentsEntity::getIsDeleted, BladeConstant.DB_NOT_DELETED);
		List<QyStudentsExcel> list = qyStudentsService.exportQyStudents(queryWrapper);
		ExcelUtil.export(response, "学员管理数据" + DateUtil.time(), "学员管理数据表", list, QyStudentsExcel.class);
	}

	public void  addRecord(User one,LinkedHashMap data){
		QyStudentsEntity find= new QyStudentsEntity();
		find.setStudentId(one.getId());
		QyStudentsEntity findOrder = qyStudentsService.getOne(Condition.getQueryWrapper(find));
		if(findOrder == null){
			QyStudentsEntity stu= new QyStudentsEntity();
			stu.setStudentId(one.getId());
			stu.setName(data.get(0).toString());

			for(int i=1;i<=8;i++){
				if(data.get(i)  !=null){
					stu.setPhoneType(String.valueOf(i));
					stu.setPhone(data.get(i).toString());
				}
			}
			SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
			//1.string->date
			try {
				if( data.get(11) != null) {
					String sdate = data.get(11).toString();
					if (!sdate.isEmpty()) {
						Date parse = dateFormat.parse(sdate);
						stu.setBirthday(parse);
					}
				}
			} catch (ParseException e) {
				throw new RuntimeException(e);
			}
			qyStudentsService.save(stu);
		}
	}




	@PostMapping("import-student")
	@ApiOperationSupport(order = 10)
	@Operation(summary = "导入数据", description  = "传入import-student")
	public R importStudent( Map<String, Object> map, MultipartFile file) {
		try {
			// 定义解析监听器，并通过实现方法获取单元格数据
			final String[] social_code = {""};

			//基本信息解析 0
			AnalysisEventListener<Object> baseListener = new AnalysisEventListener<Object>() {
				List<Object> listData = new ArrayList<>();
				@Override
				public void invoke(Object data, AnalysisContext context) {
					listData.add(data);
				}
				@Override
				public void doAfterAllAnalysed(AnalysisContext context) {

					for(int i=0;i<listData.size();i++){
						LinkedHashMap data = (LinkedHashMap) listData.get(i);
						//先添加客户表再加到报名表
						User user = new User();
						user.setTenantId(AuthUtil.getTenantId());
						for(int j=1;j<=8;j++){
							if(data.get(j)  !=null){
								user.setAccount(data.get(j).toString());
							}
						}
						user.setPassword(DigestUtil.encrypt(CommonConstant.DEFAULT_PASSWORD));//设置默认密码
						User one = userService.getOne(Condition.getQueryWrapper(user));//如果不存在
						if(one== null){
							//如果不存在则添入姓名并添加。
							user.setName(data.get(0).toString());
							user.setRealName(data.get(0).toString());
							//先写死
							user.setRoleId("1803606436115193858");
							user.setDeptId("1803588450055012353");
							user.setPostId("1803606762721452034");
							userService.save(user);
							addRecord(user,data);
						} else{
							addRecord(one,data);
						}
					}
				}
			};

		EasyExcel.read(file.getInputStream(), baseListener).sheet(0).doRead();

	} catch (Exception e) {
		e.printStackTrace();
		return R.data("导入失败");
	}
		return R.data("导入成功");
	}



}
